package com.xiaowenxiong.dao;

import com.xiaowenxiong.entity.Sc;
import com.xiaowenxiong.entity.ScKey;
import org.apache.ibatis.annotations.Param;

public interface ScMapper {
    int deleteByPrimaryKey(ScKey key);

    int insert(Sc record);

    int insertSelective(Sc record);

    Sc selectByPrimaryKey(ScKey key);

    int updateByPrimaryKeySelective(Sc record);

    int updateByPrimaryKey(Sc record);

    /**
     * 查询学生学分
     * @param sno 学号
     * @return
     */
    Double selectCcredit(@Param(value = "sno") String sno);

    /**
     * 删除一个学生所有成绩记录
     * @param sno
     * @return
     */
    int delete(@Param(value = "sno") String sno);
}